<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
require_once dirname(__FILE__).'/include/common.inc.php';
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Phpcms2008 最新文章</title>
<link href="admin/skin/system.css" rel="stylesheet" type="text/css">
<script language="javascript" src="data/config.js"></script>
<script language="javascript" src="images/js/jquery.min.js"></script>
<script language="javascript" src="images/js/common.js"></script>
</head>
<body style="margin-top:20px">
<table cellpadding="0" cellspacing="1" class="table_list" style="width:92%;">
<caption>最近发布的信息</caption>
<tr>
<th width="40">ID</th>
<th>标题</th>
<th width="50">点击量</th>
<th width="70">发布人</th>
<th width="200">更新时间</th>
</tr>
<?php
$sql="select a.title,a.contentid,a.username,a.url,a.inputtime,b.hits from ".DB_PRE."content a inner join ".DB_PRE."content_count b on a.contentid=b.contentid order by contentid desc limit 100";
$re=$db->query($sql);
while($r=$db->fetch_array($re))
{
?>
<tr>
	<td><?php echo $r[contentid];?></td>
	<td><a href="<?php echo $r[url];?>" target="_blank"><?php echo $r[title];?></a> &nbsp;</td>
	<td class="align_c"><?php echo $r[hits];?></td>
	<td class="align_c"><?php echo $r[username];?></td>
	<td class="align_c"><?php echo date("Y-m-d H:i:s",$r[inputtime]);?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>